<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsKonsSem" targetNamespace="http://tempuri.org/dsKonsSem.xsd" xmlns:mstns="http://tempuri.org/dsKonsSem.xsd" xmlns="http://tempuri.org/dsKonsSem.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="p301ConnString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="p301ConnString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.p301.Properties.Settings.GlobalReference.Default.p301ConnString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSem" GeneratorDataComponentClassName="taKonsSem" Name="dtKonsSem" UserDataComponentName="taKonsSem">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.bo_kons_sem_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT '[' + cast(NOM_KAT_SEM as varchar(10)) + '] ' + N_KAT_SEM as N_KAT_SEM, bo_kons_sem_.*
FROM 
(
SELECT K_KAT_SEM, K_KONS_SEM FROM bo_kons_sem_ where K_KONS_SEM = @pK_KONS_SEM
union
SELECT K_KAT_SEM, K_KONS_SEM FROM bo_kons_sem_type_ where K_KONS_SEM = @pK_KONS_SEM
union
SELECT K_KAT_SEM, K_KONS_SEM FROM bo_kons_sem_zan_ where K_KONS_SEM = @pK_KONS_SEM
) AS t INNER JOIN s_kat_sem ON t.K_KAT_SEM = s_kat_sem.K_KAT_SEM
	LEFT JOIN bo_kons_sem_ ON t.K_KAT_SEM = bo_kons_sem_.K_KAT_SEM AND bo_kons_sem_.K_KONS_SEM = @pK_KONS_SEM
ORDER BY NOM_KAT_SEM</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="C_PATR" DataSetColumn="C_PATR" />
              <Mapping SourceColumn="C_CHELDER" DataSetColumn="C_CHELDER" />
              <Mapping SourceColumn="C_SEM" DataSetColumn="C_SEM" />
              <Mapping SourceColumn="C_LUDI" DataSetColumn="C_LUDI" />
              <Mapping SourceColumn="K_KAT_SEM" DataSetColumn="K_KAT_SEM" />
              <Mapping SourceColumn="K_KONS_SEM" DataSetColumn="K_KONS_SEM" />
              <Mapping SourceColumn="N_KAT_SEM" DataSetColumn="N_KAT_SEM" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSemList" GeneratorDataComponentClassName="taKonsSemList" Name="dtKonsSemList" UserDataComponentName="taKonsSemList">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.vRepKonsSemList" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_KONS_SEM, N_PERIOD, D_ZAP
FROM         vRepKonsSemList
WHERE     (K_KONS_SEM = @pK_KONS_SEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.vRepKonsSemList" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KONS_SEM" DataSetColumn="K_KONS_SEM" />
              <Mapping SourceColumn="N_PERIOD" DataSetColumn="N_PERIOD" />
              <Mapping SourceColumn="D_ZAP" DataSetColumn="D_ZAP" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSemType" GeneratorDataComponentClassName="taKonsSemType" Name="dtKonsSemType" UserDataComponentName="taKonsSemType">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.bo_kons_sem_type_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [bo_kons_sem_type_] ([K_KAT_SEM], [K_KONS], [F_DETI], [C_KONS]) VALUES (@K_KAT_SEM, @K_KONS, @F_DETI, @C_KONS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DETI" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DETI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_KAT_SEM, K_KONS, F_DETI, C_KONS
FROM         bo_kons_sem_type_
WHERE     (K_KONS_SEM = @pK_KONS_SEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_type_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KAT_SEM" DataSetColumn="K_KAT_SEM" />
              <Mapping SourceColumn="K_KONS" DataSetColumn="K_KONS" />
              <Mapping SourceColumn="F_DETI" DataSetColumn="F_DETI" />
              <Mapping SourceColumn="C_KONS" DataSetColumn="C_KONS" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSemZan" GeneratorDataComponentClassName="taKonsSemZan" Name="dtKonsSemZan" UserDataComponentName="taKonsSemZan">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.bo_kons_sem_zan_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [bo_kons_sem_zan_] ([K_KONS_SEM], [K_ZAN], [F_DETI], [C_KONS], [K_KAT_SEM]) VALUES (@K_KONS_SEM, @K_ZAN, @F_DETI, @C_KONS, @K_KAT_SEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ZAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ZAN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DETI" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DETI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@C_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="C_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KAT_SEM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KAT_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_KONS_SEM, K_ZAN, F_DETI, C_KONS, K_KAT_SEM
FROM         bo_kons_sem_zan_
WHERE     (K_KONS_SEM = @pK_KONS_SEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_zan_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KONS_SEM" DataSetColumn="K_KONS_SEM" />
              <Mapping SourceColumn="K_ZAN" DataSetColumn="K_ZAN" />
              <Mapping SourceColumn="F_DETI" DataSetColumn="F_DETI" />
              <Mapping SourceColumn="C_KONS" DataSetColumn="C_KONS" />
              <Mapping SourceColumn="K_KAT_SEM" DataSetColumn="K_KAT_SEM" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsTypeList" GeneratorDataComponentClassName="taKonsTypeList" Name="dtKonsTypeList" UserDataComponentName="taKonsTypeList">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.s_kons" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     s_kons.N_KONS, s_kons.K_KONS
FROM         bo_kons_sem_type_ INNER JOIN
                      s_kons ON bo_kons_sem_type_.K_KONS = s_kons.K_KONS
WHERE     (bo_kons_sem_type_.K_KONS_SEM = @pK_KONS_SEM)
GROUP BY s_kons.N_KONS, s_kons.K_KONS</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_type_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="N_KONS" DataSetColumn="N_KONS" />
              <Mapping SourceColumn="K_KONS" DataSetColumn="K_KONS" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSemZanList" GeneratorDataComponentClassName="taKonsSemZanList" Name="dtKonsSemZanList" UserDataComponentName="taKonsSemZanList">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.s_zan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     s_zan.N_ZAN, s_zan.K_ZAN
FROM         bo_kons_sem_zan_ INNER JOIN
                      s_zan ON bo_kons_sem_zan_.K_ZAN = s_zan.K_ZAN
WHERE     (bo_kons_sem_zan_.K_KONS_SEM = @pK_KONS_SEM)
GROUP BY s_zan.N_ZAN, s_zan.K_ZAN
ORDER BY s_zan.N_ZAN</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_zan_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="N_ZAN" DataSetColumn="N_ZAN" />
              <Mapping SourceColumn="K_ZAN" DataSetColumn="K_ZAN" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKonsSemSprav" GeneratorDataComponentClassName="taKonsSemSprav" Name="dtKonsSemSprav" UserDataComponentName="taKonsSemSprav">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.bo_kons_sem_sprav_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     C_KONS_SEM_3_46, C_KONS_SEM_3_46_LUDI, C_DETI_MLADSH_3_46, C_DETI_STARSH_3_46
FROM         bo_kons_sem_sprav_
WHERE     (K_KONS_SEM = @pK_KONS_SEM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KONS_SEM" ColumnName="K_KONS_SEM" DataSourceName="p301.dbo.bo_kons_sem_sprav_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KONS_SEM" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KONS_SEM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="C_KONS_SEM_3_46" DataSetColumn="C_KONS_SEM_3_46" />
              <Mapping SourceColumn="C_KONS_SEM_3_46_LUDI" DataSetColumn="C_KONS_SEM_3_46_LUDI" />
              <Mapping SourceColumn="C_DETI_MLADSH_3_46" DataSetColumn="C_DETI_MLADSH_3_46" />
              <Mapping SourceColumn="C_DETI_STARSH_3_46" DataSetColumn="C_DETI_STARSH_3_46" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsKonsSem" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsKonsSem" msprop:Generator_DataSetName="dsKonsSem">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtKonsSem" msprop:Generator_UserTableName="dtKonsSem" msprop:Generator_RowDeletedName="dtKonsSemRowDeleted" msprop:Generator_RowChangedName="dtKonsSemRowChanged" msprop:Generator_RowClassName="dtKonsSemRow" msprop:Generator_RowChangingName="dtKonsSemRowChanging" msprop:Generator_RowEvArgName="dtKonsSemRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemRowChangeEventHandler" msprop:Generator_TableClassName="dtKonsSemDataTable" msprop:Generator_TableVarName="tabledtKonsSem" msprop:Generator_RowDeletingName="dtKonsSemRowDeleting" msprop:Generator_TablePropName="dtKonsSem">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="C_PATR" msprop:Generator_UserColumnName="C_PATR" msprop:Generator_ColumnVarNameInTable="columnC_PATR" msprop:Generator_ColumnPropNameInRow="C_PATR" msprop:Generator_ColumnPropNameInTable="C_PATRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_CHELDER" msprop:Generator_UserColumnName="C_CHELDER" msprop:Generator_ColumnVarNameInTable="columnC_CHELDER" msprop:Generator_ColumnPropNameInRow="C_CHELDER" msprop:Generator_ColumnPropNameInTable="C_CHELDERColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_SEM" msprop:Generator_UserColumnName="C_SEM" msprop:Generator_ColumnVarNameInTable="columnC_SEM" msprop:Generator_ColumnPropNameInRow="C_SEM" msprop:Generator_ColumnPropNameInTable="C_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_LUDI" msprop:Generator_UserColumnName="C_LUDI" msprop:Generator_ColumnVarNameInTable="columnC_LUDI" msprop:Generator_ColumnPropNameInRow="C_LUDI" msprop:Generator_ColumnPropNameInTable="C_LUDIColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KAT_SEM" msprop:Generator_UserColumnName="K_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KAT_SEM" msprop:Generator_ColumnPropNameInRow="K_KAT_SEM" msprop:Generator_ColumnPropNameInTable="K_KAT_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KONS_SEM" msprop:Generator_UserColumnName="K_KONS_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KONS_SEM" msprop:Generator_ColumnPropNameInRow="K_KONS_SEM" msprop:Generator_ColumnPropNameInTable="K_KONS_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_KAT_SEM" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnN_KAT_SEM" msprop:Generator_ColumnPropNameInRow="N_KAT_SEM" msprop:Generator_ColumnPropNameInTable="N_KAT_SEMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsSemList" msprop:Generator_UserTableName="dtKonsSemList" msprop:Generator_RowDeletedName="dtKonsSemListRowDeleted" msprop:Generator_RowChangedName="dtKonsSemListRowChanged" msprop:Generator_RowClassName="dtKonsSemListRow" msprop:Generator_RowChangingName="dtKonsSemListRowChanging" msprop:Generator_RowEvArgName="dtKonsSemListRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemListRowChangeEventHandler" msprop:Generator_TableClassName="dtKonsSemListDataTable" msprop:Generator_TableVarName="tabledtKonsSemList" msprop:Generator_RowDeletingName="dtKonsSemListRowDeleting" msprop:Generator_TablePropName="dtKonsSemList">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KONS_SEM" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KONS_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KONS_SEM" msprop:Generator_ColumnPropNameInRow="K_KONS_SEM" msprop:Generator_ColumnPropNameInTable="K_KONS_SEMColumn" type="xs:int" />
              <xs:element name="N_PERIOD" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_PERIOD" msprop:Generator_ColumnVarNameInTable="columnN_PERIOD" msprop:Generator_ColumnPropNameInRow="N_PERIOD" msprop:Generator_ColumnPropNameInTable="N_PERIODColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="D_ZAP" msprop:Generator_UserColumnName="D_ZAP" msprop:Generator_ColumnVarNameInTable="columnD_ZAP" msprop:Generator_ColumnPropNameInRow="D_ZAP" msprop:Generator_ColumnPropNameInTable="D_ZAPColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsSemType" msprop:Generator_UserTableName="dtKonsSemType" msprop:Generator_RowDeletedName="dtKonsSemTypeRowDeleted" msprop:Generator_RowChangedName="dtKonsSemTypeRowChanged" msprop:Generator_RowClassName="dtKonsSemTypeRow" msprop:Generator_RowChangingName="dtKonsSemTypeRowChanging" msprop:Generator_RowEvArgName="dtKonsSemTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemTypeRowChangeEventHandler" msprop:Generator_TableClassName="dtKonsSemTypeDataTable" msprop:Generator_TableVarName="tabledtKonsSemType" msprop:Generator_RowDeletingName="dtKonsSemTypeRowDeleting" msprop:Generator_TablePropName="dtKonsSemType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KAT_SEM" msprop:Generator_UserColumnName="K_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KAT_SEM" msprop:Generator_ColumnPropNameInRow="K_KAT_SEM" msprop:Generator_ColumnPropNameInTable="K_KAT_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KONS" msprop:Generator_UserColumnName="K_KONS" msprop:Generator_ColumnVarNameInTable="columnK_KONS" msprop:Generator_ColumnPropNameInRow="K_KONS" msprop:Generator_ColumnPropNameInTable="K_KONSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_DETI" msprop:Generator_UserColumnName="F_DETI" msprop:Generator_ColumnVarNameInTable="columnF_DETI" msprop:Generator_ColumnPropNameInRow="F_DETI" msprop:Generator_ColumnPropNameInTable="F_DETIColumn" type="xs:boolean" />
              <xs:element name="C_KONS" msprop:Generator_UserColumnName="C_KONS" msprop:Generator_ColumnVarNameInTable="columnC_KONS" msprop:Generator_ColumnPropNameInRow="C_KONS" msprop:Generator_ColumnPropNameInTable="C_KONSColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsSemZan" msprop:Generator_UserTableName="dtKonsSemZan" msprop:Generator_RowDeletedName="dtKonsSemZanRowDeleted" msprop:Generator_RowChangedName="dtKonsSemZanRowChanged" msprop:Generator_RowClassName="dtKonsSemZanRow" msprop:Generator_RowChangingName="dtKonsSemZanRowChanging" msprop:Generator_RowEvArgName="dtKonsSemZanRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemZanRowChangeEventHandler" msprop:Generator_TableClassName="dtKonsSemZanDataTable" msprop:Generator_TableVarName="tabledtKonsSemZan" msprop:Generator_RowDeletingName="dtKonsSemZanRowDeleting" msprop:Generator_TablePropName="dtKonsSemZan">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KONS_SEM" msprop:Generator_UserColumnName="K_KONS_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KONS_SEM" msprop:Generator_ColumnPropNameInRow="K_KONS_SEM" msprop:Generator_ColumnPropNameInTable="K_KONS_SEMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_ZAN" msprop:Generator_UserColumnName="K_ZAN" msprop:Generator_ColumnVarNameInTable="columnK_ZAN" msprop:Generator_ColumnPropNameInRow="K_ZAN" msprop:Generator_ColumnPropNameInTable="K_ZANColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_DETI" msprop:Generator_UserColumnName="F_DETI" msprop:Generator_ColumnVarNameInTable="columnF_DETI" msprop:Generator_ColumnPropNameInRow="F_DETI" msprop:Generator_ColumnPropNameInTable="F_DETIColumn" type="xs:boolean" />
              <xs:element name="C_KONS" msprop:Generator_UserColumnName="C_KONS" msprop:Generator_ColumnVarNameInTable="columnC_KONS" msprop:Generator_ColumnPropNameInRow="C_KONS" msprop:Generator_ColumnPropNameInTable="C_KONSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_KAT_SEM" msprop:Generator_UserColumnName="K_KAT_SEM" msprop:Generator_ColumnVarNameInTable="columnK_KAT_SEM" msprop:Generator_ColumnPropNameInRow="K_KAT_SEM" msprop:Generator_ColumnPropNameInTable="K_KAT_SEMColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsTypeList" msprop:Generator_UserTableName="dtKonsTypeList" msprop:Generator_RowDeletedName="dtKonsTypeListRowDeleted" msprop:Generator_RowChangedName="dtKonsTypeListRowChanged" msprop:Generator_RowClassName="dtKonsTypeListRow" msprop:Generator_RowChangingName="dtKonsTypeListRowChanging" msprop:Generator_RowEvArgName="dtKonsTypeListRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsTypeListRowChangeEventHandler" msprop:Generator_TableClassName="dtKonsTypeListDataTable" msprop:Generator_TableVarName="tabledtKonsTypeList" msprop:Generator_RowDeletingName="dtKonsTypeListRowDeleting" msprop:Generator_TablePropName="dtKonsTypeList">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="N_KONS" msprop:Generator_UserColumnName="N_KONS" msprop:Generator_ColumnPropNameInRow="N_KONS" msprop:Generator_ColumnVarNameInTable="columnN_KONS" msprop:Generator_ColumnPropNameInTable="N_KONSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_KONS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KONS" msprop:Generator_ColumnPropNameInRow="K_KONS" msprop:Generator_ColumnVarNameInTable="columnK_KONS" msprop:Generator_ColumnPropNameInTable="K_KONSColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsSemZanList" msprop:Generator_UserTableName="dtKonsSemZanList" msprop:Generator_RowDeletedName="dtKonsSemZanListRowDeleted" msprop:Generator_TableClassName="dtKonsSemZanListDataTable" msprop:Generator_RowChangedName="dtKonsSemZanListRowChanged" msprop:Generator_RowClassName="dtKonsSemZanListRow" msprop:Generator_RowChangingName="dtKonsSemZanListRowChanging" msprop:Generator_RowEvArgName="dtKonsSemZanListRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemZanListRowChangeEventHandler" msprop:Generator_TablePropName="dtKonsSemZanList" msprop:Generator_TableVarName="tabledtKonsSemZanList" msprop:Generator_RowDeletingName="dtKonsSemZanListRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="N_ZAN" msprop:Generator_UserColumnName="N_ZAN" msprop:Generator_ColumnPropNameInRow="N_ZAN" msprop:Generator_ColumnVarNameInTable="columnN_ZAN" msprop:Generator_ColumnPropNameInTable="N_ZANColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_ZAN" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_ZAN" msprop:Generator_ColumnPropNameInRow="K_ZAN" msprop:Generator_ColumnVarNameInTable="columnK_ZAN" msprop:Generator_ColumnPropNameInTable="K_ZANColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKonsSemSprav" msprop:Generator_UserTableName="dtKonsSemSprav" msprop:Generator_RowDeletedName="dtKonsSemSpravRowDeleted" msprop:Generator_TableClassName="dtKonsSemSpravDataTable" msprop:Generator_RowChangedName="dtKonsSemSpravRowChanged" msprop:Generator_RowClassName="dtKonsSemSpravRow" msprop:Generator_RowChangingName="dtKonsSemSpravRowChanging" msprop:Generator_RowEvArgName="dtKonsSemSpravRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKonsSemSpravRowChangeEventHandler" msprop:Generator_TablePropName="dtKonsSemSprav" msprop:Generator_TableVarName="tabledtKonsSemSprav" msprop:Generator_RowDeletingName="dtKonsSemSpravRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="C_KONS_SEM_3_46" msprop:Generator_UserColumnName="C_KONS_SEM_3_46" msprop:Generator_ColumnPropNameInRow="C_KONS_SEM_3_46" msprop:Generator_ColumnVarNameInTable="columnC_KONS_SEM_3_46" msprop:Generator_ColumnPropNameInTable="C_KONS_SEM_3_46Column" type="xs:int" minOccurs="0" />
              <xs:element name="C_KONS_SEM_3_46_LUDI" msprop:Generator_UserColumnName="C_KONS_SEM_3_46_LUDI" msprop:Generator_ColumnPropNameInRow="C_KONS_SEM_3_46_LUDI" msprop:Generator_ColumnVarNameInTable="columnC_KONS_SEM_3_46_LUDI" msprop:Generator_ColumnPropNameInTable="C_KONS_SEM_3_46_LUDIColumn" type="xs:int" minOccurs="0" />
              <xs:element name="C_DETI_MLADSH_3_46" msprop:Generator_UserColumnName="C_DETI_MLADSH_3_46" msprop:Generator_ColumnPropNameInRow="C_DETI_MLADSH_3_46" msprop:Generator_ColumnVarNameInTable="columnC_DETI_MLADSH_3_46" msprop:Generator_ColumnPropNameInTable="C_DETI_MLADSH_3_46Column" type="xs:int" minOccurs="0" />
              <xs:element name="C_DETI_STARSH_3_46" msprop:Generator_UserColumnName="C_DETI_STARSH_3_46" msprop:Generator_ColumnPropNameInRow="C_DETI_STARSH_3_46" msprop:Generator_ColumnVarNameInTable="columnC_DETI_STARSH_3_46" msprop:Generator_ColumnPropNameInTable="C_DETI_STARSH_3_46Column" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKonsSemList" />
      <xs:field xpath="mstns:K_KONS_SEM" />
    </xs:unique>
    <xs:unique name="dtKonsTypeList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKonsTypeList" />
      <xs:field xpath="mstns:K_KONS" />
    </xs:unique>
    <xs:unique name="dtKonsSemZanList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKonsSemZanList" />
      <xs:field xpath="mstns:K_ZAN" />
    </xs:unique>
  </xs:element>
</xs:schema>